-
Re: How to format text in a row all at once to be uniform
Easy to remove the dash "-" but not sure about adding the "." so can only half help… If you're not using the dash elsewhere in the sheet, you could do a find and replace: Ctrl F U…1 · -
Re: Parent Color Symbol, Based on "Average" of Child Symbols
Hi! I think that averages require associated number values (which I usually put in a helper column) Without that the best I could suggest would be: =IF(COUNTIF(CHILDREN(), "Red") = COUNT(CH…1 ·